package com.cjack.frenchexcel.model;

import com.sargeraswang.util.ExcelUtil.ExcelCell;
import lombok.Data;

import java.io.Serializable;
import java.util.LinkedHashMap;
import java.util.Map;

/**
 * 消费数据导入模型
 */
@Data
public class NewImportConsumerModel implements Serializable {
    /**
     * 日期
     */
    @ExcelCell(index = 1)
    private String dateDeDepense;
    /**
     * 合作商
     */
    @ExcelCell(index = 2)
    private String fournisseur;
    /**
     * 消费
     */
    @ExcelCell(index = 3)
    private String montantTTC1;
    /**
     * 收入
     */
    @ExcelCell(index = 4)
    private String montantTTC2;
    /**
     * 银行卡号
     */
    @ExcelCell(index = 5)
    private String carteIdentifiant;

    public static Map<String,String> getColMap(){
        //用排序的Map且Map的键应与ExcelCell注解的index对应
        Map<String,String> map = new LinkedHashMap<>();
        map.put( "a", "Date de dépense");
        map.put( "b", "Date de débit");
        map.put( "c", "Justif.");
        map.put( "d", "Collaborateur");
        map.put( "e", "Carte Identifiant");
        map.put( "f", "Description");
        map.put( "g", "Fournisseur");
        map.put( "h", "Nature");
        map.put( "i", "Montant en devise");
        map.put( "j", "Devise originale");
        map.put( "k", "Montant HT");
        map.put( "l", "TVA récup.");
        map.put( "m", "TVA non récup.");
        map.put( "n", "Montant TTC");
        map.put( "o", "Montant charge");
        return map;
    }
}
